A Model for a Temporal Data Warehouse

Data warehouses are a primary means for a consolidated view on the data within an enterprise and frequently a rst step in integrating enterprise information systems. Above all, data warehouses are used for analyzing enterprise data online, giving the possibility to aggregate and compare data along dimensions relevant in the application domain. Typically time is one of the dimensions we nd in data warehouses allowing comparisons of di erent periods. The instances of dimensions, however, change over time countries unite and separate, products emerge and vanish, organizational structures evolve. In current data warehouse technology these changes cannot be represented adequately since all dimensions are (implicitly) considered as orthogonal, putting heavy restrictions on the validity of OLAP queries spanning several periods. In this paper we brie y propose an architecture for temporal data warehouse systems which allows the registration of temporal versions of dimension data and the transfer of data between di erent temporal versions.